Ulabox_ecommerce
Nguyen_LSCM
3/24/2020
Load packages
Introduction
Ulabox is a Spainish start-up. The range of products is mainly focus on packaged foods,So it is easy to understand that supply chain is the key to compete with others, such as Amazon,… Ulabox has opened 3 warehouses: 2 in Barcelona and 1 Madrid. Fresh food like fish, vegetable and household items are core value of Ulabox to compete with giant Amazon. Nearly, It has coporated with other businesses. Widen products to have more energies and widen customers is a recent strategy of Ulabox.
If you want to know more, please to feel free with seaching this link Ulabox
I also did other ecommerce in notebook. It is a Olist ecommerce from Brazil, operating model is different from Ulabox.
Load datasets
View datasets and explain
- Customer: It likes a customerid to determine unique objective
- Order: It likes a orderid to determine unique objective
- Total_Item: The number of products that customer places an order in one time
- Discount: This is an percentage of value order,it means that the ratio of discount value and order value
- Weekday: The days are from Monday to Sunday. For example, 1 is Monday and 7 is Sunday
- hour: The hours are from 0-23
- food, fresh, drinks, home, beauty,baby and pets: are the products of Ulabox platform
| customer | order | total_items | discount. | weekday | hour | food | fresh | drinks | home | beauty | health | baby | pets |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 45 | 23.03 | 4 | 13 | 9.46 | 87.06 | 3.48 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 0 | 1 | 38 | 1.22 | 5 | 13 | 15.87 | 75.80 | 6.22 | 2.12 | 0.00 | 0.00 | 0.0 | 0 |
| 0 | 2 | 51 | 18.08 | 4 | 13 | 16.88 | 56.75 | 3.37 | 16.48 | 6.53 | 0.00 | 0.0 | 0 |
| 1 | 3 | 57 | 16.51 | 1 | 12 | 28.81 | 35.99 | 11.78 | 4.62 | 2.87 | 15.92 | 0.0 | 0 |
| 1 | 4 | 53 | 18.31 | 2 | 11 | 24.13 | 60.38 | 7.78 | 7.72 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 5 | 8 | 23.89 | 4 | 13 | 0.00 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 6 | 35 | 17.26 | 1 | 10 | 13.01 | 51.84 | 29.36 | 5.79 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 7 | 12 | 6.61 | 4 | 8 | 17.21 | 67.93 | 14.86 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 8 | 35 | 22.29 | 1 | 12 | 15.50 | 61.65 | 22.85 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 9 | 44 | 20.39 | 2 | 12 | 15.29 | 44.11 | 12.28 | 8.90 | 15.53 | 3.90 | 0.0 | 0 |
| 1 | 10 | 17 | 18.41 | 4 | 9 | 16.92 | 70.15 | 12.93 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 11 | 7 | 15.00 | 1 | 8 | 0.00 | 39.93 | 60.07 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 12 | 30 | 18.86 | 1 | 9 | 22.90 | 40.36 | 14.47 | 10.68 | 0.00 | 11.58 | 0.0 | 0 |
| 1 | 13 | 35 | 16.38 | 1 | 11 | 11.46 | 79.06 | 9.48 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 14 | 32 | 17.41 | 1 | 10 | 13.37 | 45.57 | 28.61 | 0.00 | 0.00 | 12.46 | 0.0 | 0 |
| 1 | 15 | 27 | 21.80 | 1 | 9 | 48.23 | 20.37 | 15.38 | 8.29 | 7.73 | 0.00 | 0.0 | 0 |
| 1 | 16 | 38 | 17.31 | 1 | 11 | 12.88 | 64.26 | 9.43 | 0.00 | 13.42 | 0.00 | 0.0 | 0 |
| 1 | 17 | 28 | 18.76 | 1 | 11 | 14.57 | 43.42 | 22.09 | 13.18 | 6.74 | 0.00 | 0.0 | 0 |
| 1 | 18 | 31 | 16.49 | 1 | 12 | 24.27 | 33.09 | 16.18 | 0.00 | 0.00 | 26.47 | 0.0 | 0 |
| 1 | 19 | 23 | 19.52 | 1 | 13 | 23.22 | 56.85 | 19.93 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 20 | 30 | 17.89 | 2 | 11 | 14.62 | 32.77 | 18.71 | 0.00 | 0.00 | 0.00 | 33.9 | 0 |
| 1 | 21 | 45 | 17.27 | 1 | 10 | 20.19 | 63.32 | 11.53 | 4.97 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 22 | 36 | 16.62 | 5 | 9 | 18.66 | 47.13 | 17.50 | 0.00 | 0.00 | 16.71 | 0.0 | 0 |
| 2 | 23 | 26 | 2.97 | 6 | 23 | 24.10 | 22.29 | 38.69 | 14.92 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 24 | 28 | 2.21 | 1 | 10 | 36.51 | 31.93 | 27.18 | 4.38 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 25 | 67 | 4.19 | 7 | 21 | 12.47 | 68.13 | 3.46 | 15.93 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 26 | 27 | 3.23 | 1 | 10 | 25.45 | 36.17 | 10.34 | 28.03 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 27 | 6 | 0.00 | 2 | 20 | 12.50 | 67.74 | 0.00 | 19.76 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 28 | 27 | 5.80 | 1 | 13 | 5.20 | 65.05 | 13.30 | 16.45 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 29 | 19 | 0.00 | 4 | 12 | 28.26 | 56.40 | 15.34 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
Data Analysis
I will cover some aspects below: - 1. Time aspect - 2. Product aspect - 3. Order times, discount
Time aspect
Distribution of Hour and Weekday
- Hour aspect
- Weekday aspect
- Weekday compared to Hour aspect
Product aspect
Distribution of range of products
Boxplot
